Page 135 - 2629_Devagiri_C-8
P. 135
PROJECT PRACTICE
21 st #Critical Thinking
Century #Technology Literacy
1. Create a Class feedback form using Google Forms. The form Skills
should include multiple-choice questions as shown:
21 st #Critical Thinking
Century #Technology Literacy
2. Consider the following EMPLOYEE table: Skills
Table: EMPLOYEE
Emp_ID Name Department Salary Age
E101 Rajesh HR 35000 40
E102 Simran Sales 45000 38
E103 Aarav IT 60000 28
E104 Neha HR 37000 33
E105 Manoj Finance 52000 45
Now, write SQL commands for the following:
Create the given table under the Organisation database.
Add a new employee “Pooja” in the IT department, salary 48000, age 29, Emp_ID E106.
List the names and departments of all employees earning more than 40,000.
Show the names of employees who work in the HR department.
Delete all employees from the IT department.
133
Project Practice
